-
Re: Formula to display cell content based on health status?
This is off the top of my head, but this is how I'd do this: Create a report (File>New Report), add the filter to include all rows with an "Overall Health" column value of "Red"…1 · -
Re: How do i get a cell to return a TEXT value based on several IF criteria from other cells?
This ought to do it: =IF(AND([IMS audit]@row = true, [IMS Audit Scheduled Date]@row = ""), "Awaiting Scheduling", IF(AND([IMS audit]@row = true, [IMS Audit Scheduled Date]@row <…1 · -
Re: Scoring Formulas
PS you could use a CONTAINS function to make this easier for Yes/No responses. Something like: =IF(CONTAINS("Yes", [Receivership Pre]@row), 1, 0)1 · -
Re: Set RAG based on % Complete & Deadline Date Proximity
Hey Cheryl, You can simplify this a bit: =IF([Deadline Date]@row > (TODAY() + 21), "Green", IF(AND([% Complete]@row <>"Full", [Deadline Date]@row > (TODAY() + 10)), &q…1 · -
Re: Linking Microsoft Documents to Smartsheet Dashboard / Works
Hey Christine, hope you're doing well. Since no one has answered this yet, I figured I'd throw my hat in the ring here. My "day job" is with a Microsoft Gold Partner IT consultancy company …1 ·